import pandas as pd
from collections import Counter

pd.options.display.max_columns=None
df=pd.read_excel('dataset.xlsx',sheet_name='Ligands',usecols=[0,1,2,4])
print(df.shape)
print(df.size)
print(df.head(5))
print(df.tail(10))

print(df[df['Formula']=='C3 H10 N2'])
print(df['PDB Entry'].head())
print(df[20:31])
print(df.loc[20,'Formula'])
print(df.iloc[20:31,5])
print(df.iat[20,4])

print(df.dtypes)
print(Counter(df.dtypes.valules))
print(df.info())
